#!/usr/bin/python3
# -*- coding:utf-8 -*-
""""
   @Author: 叶建伟
   @Email: yejw46507@hundsun.com
   @Time: 2023/5/27 12:43
   @File: rcmpTest.py
   生成内控sql数据
"""
from DataTest.tabledata import dataTest

if __name__ == '__main__':
    BRANCH_NO = '110'
    SCA_LIST_TYPE = "1"
    SCA_LIST_STATUS = "0"
    UNIFIED_CLIENT_ID= '160102011001'
    CLIENT_ID = '160102011001'
    CLIENT_NAME = '银河个性化'
    EQUIPMENT_INFO = '1'
    SERIAL_NO = '16010201100101'
    OCCUR_DATE = 20200903
    TERMINAL_TYPE = "1"
    dataTest.montage_sql(table='sec_client', BRANCH_NO=BRANCH_NO, SCA_LIST_TYPE=SCA_LIST_TYPE, SCA_LIST_STATUS=SCA_LIST_STATUS, OCCUR_DATE=OCCUR_DATE, CLIENT_ID=CLIENT_ID, EQUIPMENT_INFO=EQUIPMENT_INFO, CLIENT_NAME=CLIENT_NAME)
    dataTest.montage_sql(table='sca_pre_suspect_list', TERMINAL_TYPE=TERMINAL_TYPE, OCCUR_DATE=OCCUR_DATE, UNIFIED_CLIENT_ID=UNIFIED_CLIENT_ID, BRANCH_NO=BRANCH_NO, SCA_LIST_TYPE=SCA_LIST_TYPE, SCA_LIST_STATUS=SCA_LIST_STATUS, CLIENT_ID=CLIENT_ID, EQUIPMENT_INFO=EQUIPMENT_INFO)
    dataTest.montage_sql(table='sca_h_banktransfer', TERMINAL_TYPE=TERMINAL_TYPE, OCCUR_DATE=OCCUR_DATE, UNIFIED_CLIENT_ID=UNIFIED_CLIENT_ID, SERIAL_NO=SERIAL_NO, BRANCH_NO=BRANCH_NO, SCA_LIST_TYPE=SCA_LIST_TYPE, SCA_LIST_STATUS=SCA_LIST_STATUS, CLIENT_ID=CLIENT_ID, EQUIPMENT_INFO=EQUIPMENT_INFO)
    dataTest.montage_sql(table='sec_clientasset', TERMINAL_TYPE=TERMINAL_TYPE, OCCUR_DATE=OCCUR_DATE, UNIFIED_CLIENT_ID=UNIFIED_CLIENT_ID, SERIAL_NO=SERIAL_NO, BRANCH_NO=BRANCH_NO, SCA_LIST_TYPE=SCA_LIST_TYPE, SCA_LIST_STATUS=SCA_LIST_STATUS, CLIENT_ID=CLIENT_ID, EQUIPMENT_INFO=EQUIPMENT_INFO)
    OCCUR_DATE = 20200902
    dataTest.montage_sql(table='sec_clientasset', TERMINAL_TYPE=TERMINAL_TYPE, OCCUR_DATE=OCCUR_DATE, UNIFIED_CLIENT_ID=UNIFIED_CLIENT_ID, SERIAL_NO=SERIAL_NO, BRANCH_NO=BRANCH_NO, SCA_LIST_TYPE=SCA_LIST_TYPE, SCA_LIST_STATUS=SCA_LIST_STATUS, CLIENT_ID=CLIENT_ID, EQUIPMENT_INFO=EQUIPMENT_INFO)

    # EQUIPMENT_INFO = '2'
    # OCCUR_DATE = 20200812
    # SERIAL_NO = '16010201100102'
    # # CLIENT_ID = '1601020100023'
    # TERMINAL_TYPE = "1"
    # dataTest.montage_sql(table='sca_pre_suspect_list',TERMINAL_TYPE=TERMINAL_TYPE,OCCUR_DATE=OCCUR_DATE,UNIFIED_CLIENT_ID=UNIFIED_CLIENT_ID, BRANCH_NO=BRANCH_NO, SCA_LIST_TYPE=SCA_LIST_TYPE, SCA_LIST_STATUS=SCA_LIST_STATUS,CLIENT_ID=CLIENT_ID,EQUIPMENT_INFO=EQUIPMENT_INFO)
    # dataTest.montage_sql(table='sca_h_banktransfer',TERMINAL_TYPE=TERMINAL_TYPE,OCCUR_DATE=OCCUR_DATE,UNIFIED_CLIENT_ID=UNIFIED_CLIENT_ID,SERIAL_NO=SERIAL_NO, BRANCH_NO=BRANCH_NO, SCA_LIST_TYPE=SCA_LIST_TYPE, SCA_LIST_STATUS=SCA_LIST_STATUS,CLIENT_ID=CLIENT_ID,EQUIPMENT_INFO=EQUIPMENT_INFO)
    #
